package com.qf.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.qf.Seat;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
 * 作者：Xx凯丶
 * 时间：2022/4/25 9:34
 */
@Mapper
public interface SeatMapper extends BaseMapper<Seat> {
    @Select("SELECT  seat_id,hall_id,cinema_id,`row`,`column`,`status` \n" +
            "FROM seat     \n" +
            "WHERE (seat_id = #{seatId})")
    public Seat selectSeatById(Integer seatId);
    @Update("UPDATE seat SET `status`= 1 WHERE (seat_id = #{seatId})")
    public int updateStatusById(Integer seatId);
}
